Overview

Dataset statistics

Number of variables17
Number of observations485587
Missing cells0
Missing cells (%)0.0%
Duplicate rows524
Duplicate rows (%)0.1%
Total size in memory63.0 MiB
Average record size in memory136.0 B

Variable types

NUM9
CAT8

Warnings

Dataset has 524 (0.1%) duplicate rows Duplicates
Hotel_Address has a high cardinality: 1407 distinct values High cardinality
Review_Date has a high cardinality: 731 distinct values High cardinality
Hotel_Name has a high cardinality: 1406 distinct values High cardinality
Reviewer_Nationality has a high cardinality: 226 distinct values High cardinality
Negative_Review has a high cardinality: 310185 distinct values High cardinality
Positive_Review has a high cardinality: 388928 distinct values High cardinality
Tags has a high cardinality: 52838 distinct values High cardinality
days_since_review has a high cardinality: 731 distinct values High cardinality
Review_Total_Negative_Word_Counts has 120882 (24.9%) zeros Zeros
Review_Total_Positive_Word_Counts has 33674 (6.9%) zeros Zeros

Reproduction

Analysis started2020-12-06 07:54:28.386638
Analysis finished2020-12-06 07:55:43.989209
Duration1 minute and 15.6 seconds
Software versionpandas-profiling v2.9.0
Download configurationconfig.yaml

Variables

Hotel_Address
Categorical

HIGH CARDINALITY

Distinct1407
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.7 MiB
163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom
 
4789
372 Strand Westminster Borough London WC2R 0JJ United Kingdom
 
4256
Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom
 
3578
7 Pepys Street City of London London EC3N 4AF United Kingdom
 
3212
1 Inverness Terrace Westminster Borough London W2 3JP United Kingdom
 
2958
Other values (1402)
466794 
ValueCountFrequency (%) 
163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom47891.0%
 
372 Strand Westminster Borough London WC2R 0JJ United Kingdom42560.9%
 
Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom35780.7%
 
7 Pepys Street City of London London EC3N 4AF United Kingdom32120.7%
 
1 Inverness Terrace Westminster Borough London W2 3JP United Kingdom29580.6%
 
225 Edgware Road Westminster Borough London W2 1JU United Kingdom26280.5%
 
4 18 Harrington Gardens Kensington and Chelsea London SW7 4LH United Kingdom25650.5%
 
1 Waterview Drive Greenwich London SE10 0TW United Kingdom25510.5%
 
27 Devonshire Terrace Westminster Borough London W2 3DP United Kingdom22880.5%
 
Lakeside Way Brent London HA9 0BU United Kingdom22270.5%
 
Other values (1397)45453593.6%
 
2020-12-06T07:55:44.275192image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
2020-12-06T07:55:44.940562image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length96
Median length60
Mean length60.22076374
Min length34

Additional_Number_of_Scoring
Real number (ℝ≥0)

Distinct471
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean483.0977065
Minimum1
Maximum2682
Zeros0
Zeros (%)0.0%
Memory size3.7 MiB
2020-12-06T07:55:45.302895image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile58
Q1169
median341
Q3639
95-th percentile1427
Maximum2682
Range2681
Interquartile range (IQR)470

Descriptive statistics

Standard deviation468.5752141
Coefficient of variation (CV)0.9699388091
Kurtosis5.699915054
Mean483.0977065
Median Absolute Deviation (MAD)200
Skewness2.143064613
Sum234585966
Variance219562.7313
MonotocityNot monotonic
2020-12-06T07:55:45.661160image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
268247891.0%
 
228842560.9%
 
183135780.7%
 
193632120.7%
 
25630790.6%
 
127429580.6%
 
83229340.6%
 
148526280.5%
 
70426000.5%
 
144425650.5%
 
Other values (461)45298893.3%
 
ValueCountFrequency (%) 
113< 0.1%
 
412< 0.1%
 
539< 0.1%
 
6118< 0.1%
 
756< 0.1%
 
ValueCountFrequency (%) 
268247891.0%
 
228842560.9%
 
193632120.7%
 
183135780.7%
 
148526280.5%
 

Review_Date
Categorical

HIGH CARDINALITY

Distinct731
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.7 MiB
8/2/2017
 
2452
9/15/2016
 
2170
4/5/2017
 
2157
2/16/2016
 
1851
8/30/2016
 
1850
Other values (726)
475107 
ValueCountFrequency (%) 
8/2/201724520.5%
 
9/15/201621700.4%
 
4/5/201721570.4%
 
2/16/201618510.4%
 
8/30/201618500.4%
 
7/5/201617990.4%
 
5/31/201617670.4%
 
7/12/201617200.4%
 
12/5/201616910.3%
 
8/2/201616810.3%
 
Other values (721)46644996.1%
 
2020-12-06T07:55:46.079136image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
2020-12-06T07:55:46.406009image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length10
Median length9
Mean length8.931740347
Min length8

Average_Score
Real number (ℝ≥0)

Distinct33
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.401729659
Minimum6.4
Maximum9.8
Zeros0
Zeros (%)0.0%
Memory size3.7 MiB
2020-12-06T07:55:46.770023image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum6.4
5-th percentile7.4
Q18.1
median8.4
Q38.8
95-th percentile9.2
Maximum9.8
Range3.4
Interquartile range (IQR)0.7

Descriptive statistics

Standard deviation0.5520084327
Coefficient of variation (CV)0.06570176084
Kurtosis0.2718736294
Mean8.401729659
Median Absolute Deviation (MAD)0.4
Skewness-0.5278649874
Sum4079770.7
Variance0.3047133098
MonotocityNot monotonic
2020-12-06T07:55:47.146294image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%) 
8.4384387.9%
 
8.5369147.6%
 
8.6353707.3%
 
8.1339917.0%
 
8.2338697.0%
 
8.7319166.6%
 
8.8296426.1%
 
8.3295466.1%
 
8.9276375.7%
 
9.1211234.3%
 
Other values (23)16714134.4%
 
ValueCountFrequency (%) 
6.411630.2%
 
6.64000.1%
 
6.79650.2%
 
6.813350.3%
 
6.917370.4%
 
ValueCountFrequency (%) 
9.828< 0.1%
 
9.69150.2%
 
9.512070.2%
 
9.491261.9%
 
9.3124162.6%
 

Hotel_Name
Categorical

HIGH CARDINALITY

Distinct1406
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.7 MiB
Britannia International Hotel Canary Wharf
 
4789
Strand Palace Hotel
 
4256
Copthorne Tara Hotel London Kensington
 
3578
DoubleTree by Hilton Hotel London Tower of London
 
3212
Grand Royale London Hyde Park
 
2958
Other values (1401)
466794 
ValueCountFrequency (%) 
Britannia International Hotel Canary Wharf47891.0%
 
Strand Palace Hotel42560.9%
 
Copthorne Tara Hotel London Kensington35780.7%
 
DoubleTree by Hilton Hotel London Tower of London32120.7%
 
Grand Royale London Hyde Park29580.6%
 
Hilton London Metropole26280.5%
 
Millennium Gloucester Hotel London25650.5%
 
Intercontinental London The O225510.5%
 
Park Grand Paddington Court22880.5%
 
Hilton London Wembley22270.5%
 
Other values (1396)45453593.6%
 
2020-12-06T07:55:47.518425image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
2020-12-06T07:55:47.958419image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length60
Median length24
Mean length25.28946409
Min length2

Reviewer_Nationality
Categorical

HIGH CARDINALITY

Distinct226
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.7 MiB
United Kingdom
234554 
United States of America
33517 
Australia
 
20438
Ireland
 
13967
United Arab Emirates
 
9617
Other values (221)
173494 
ValueCountFrequency (%) 
United Kingdom 23455448.3%
 
United States of America 335176.9%
 
Australia 204384.2%
 
Ireland 139672.9%
 
United Arab Emirates 96172.0%
 
Saudi Arabia 84591.7%
 
Netherlands 81731.7%
 
Switzerland 78881.6%
 
Canada 74501.5%
 
Germany 72351.5%
 
Other values (216)13428927.7%
 
2020-12-06T07:55:48.376847image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Frequencies of value counts

Unique

Unique11 ?
Unique (%)< 0.1%
2020-12-06T07:55:48.806260image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length38
Median length16
Mean length14.09081998
Min length1

Negative_Review
Categorical

HIGH CARDINALITY

Distinct310185
Distinct (%)63.9%
Missing0
Missing (%)0.0%
Memory size3.7 MiB
No Negative
120882 
Nothing
 
13645
Nothing
 
4005
nothing
 
2098
N A
 
978
Other values (310180)
343979 
ValueCountFrequency (%) 
No Negative12088224.9%
 
Nothing136452.8%
 
Nothing 40050.8%
 
nothing20980.4%
 
N A9780.2%
 
None9300.2%
 
7720.2%
 
N a4880.1%
 
Breakfast3660.1%
 
Small room3540.1%
 
Other values (310175)34106970.2%
 
2020-12-06T07:55:51.514647image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Frequencies of value counts

Unique

Unique304056 ?
Unique (%)62.6%
2020-12-06T07:55:51.921639image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length1966
Median length41
Mean length93.31664357
Min length1

Review_Total_Negative_Word_Counts
Real number (ℝ≥0)

ZEROS

Distinct401
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.44299374
Minimum0
Maximum408
Zeros120882
Zeros (%)24.9%
Memory size3.7 MiB
2020-12-06T07:55:52.367445image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median9
Q323
95-th percentile68
Maximum408
Range408
Interquartile range (IQR)21

Descriptive statistics

Standard deviation29.57196064
Coefficient of variation (CV)1.603425185
Kurtosis31.62702363
Mean18.44299374
Median Absolute Deviation (MAD)9
Skewness4.419364711
Sum8955678
Variance874.5008561
MonotocityNot monotonic
2020-12-06T07:55:52.678600image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
012088224.9%
 
2233184.8%
 
3171733.5%
 
6167663.5%
 
5158113.3%
 
7151843.1%
 
4142372.9%
 
8139112.9%
 
9128682.6%
 
10116832.4%
 
Other values (391)22375446.1%
 
ValueCountFrequency (%) 
012088224.9%
 
2233184.8%
 
3171733.5%
 
4142372.9%
 
5158113.3%
 
ValueCountFrequency (%) 
4081< 0.1%
 
4032< 0.1%
 
4021< 0.1%
 
4011< 0.1%
 
3992< 0.1%
 

Total_Number_of_Reviews
Real number (ℝ≥0)

Distinct1087
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2576.012566
Minimum43
Maximum9568
Zeros0
Zeros (%)0.0%
Memory size3.7 MiB
2020-12-06T07:55:53.059363image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum43
5-th percentile423
Q11140
median2058
Q33550
95-th percentile6977
Maximum9568
Range9525
Interquartile range (IQR)2410

Descriptive statistics

Standard deviation1950.174415
Coefficient of variation (CV)0.7570515922
Kurtosis1.793005789
Mean2576.012566
Median Absolute Deviation (MAD)1059
Skewness1.372746894
Sum1250878214
Variance3803180.248
MonotocityNot monotonic
2020-12-06T07:55:53.342121image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
908647891.0%
 
956842560.9%
 
710535780.7%
 
749132120.7%
 
653929580.6%
 
697726280.5%
 
572625650.5%
 
420425510.5%
 
660822880.5%
 
430522270.5%
 
Other values (1077)45453593.6%
 
ValueCountFrequency (%) 
4312< 0.1%
 
4512< 0.1%
 
4940< 0.1%
 
5113< 0.1%
 
5413< 0.1%
 
ValueCountFrequency (%) 
956842560.9%
 
908647891.0%
 
817718090.4%
 
758616860.3%
 
749132120.7%
 

Positive_Review
Categorical

HIGH CARDINALITY

Distinct388928
Distinct (%)80.1%
Missing0
Missing (%)0.0%
Memory size3.7 MiB
No Positive
 
33674
Location
 
8747
Everything
 
2153
location
 
1590
Nothing
 
1168
Other values (388923)
438255 
ValueCountFrequency (%) 
No Positive336746.9%
 
Location87471.8%
 
Everything21530.4%
 
location15900.3%
 
Nothing11680.2%
 
The location10860.2%
 
Great location9920.2%
 
Good location8890.2%
 
Location 8730.2%
 
Everything 5740.1%
 
Other values (388918)43384189.3%
 
2020-12-06T07:55:56.874245image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Frequencies of value counts

Unique

Unique379997 ?
Unique (%)78.3%
2020-12-06T07:55:57.298401image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length1960
Median length59
Mean length94.66395929
Min length1

Review_Total_Positive_Word_Counts
Real number (ℝ≥0)

ZEROS

Distinct364
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.78124414
Minimum0
Maximum395
Zeros33674
Zeros (%)6.9%
Memory size3.7 MiB
2020-12-06T07:55:57.728473image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q15
median11
Q322
95-th percentile56
Maximum395
Range395
Interquartile range (IQR)17

Descriptive statistics

Standard deviation21.80042826
Coefficient of variation (CV)1.226035034
Kurtosis32.90596346
Mean17.78124414
Median Absolute Deviation (MAD)7
Skewness4.189315203
Sum8634341
Variance475.2586723
MonotocityNot monotonic
2020-12-06T07:55:58.166295image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0336746.9%
 
6253485.2%
 
5252525.2%
 
4232024.8%
 
7231174.8%
 
8218764.5%
 
3212704.4%
 
9199044.1%
 
2197254.1%
 
10185483.8%
 
Other values (354)25367152.2%
 
ValueCountFrequency (%) 
0336746.9%
 
2197254.1%
 
3212704.4%
 
4232024.8%
 
5252525.2%
 
ValueCountFrequency (%) 
3951< 0.1%
 
3861< 0.1%
 
3842< 0.1%
 
3832< 0.1%
 
3821< 0.1%
 
Distinct195
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.102294748
Minimum1
Maximum355
Zeros0
Zeros (%)0.0%
Memory size3.7 MiB
2020-12-06T07:55:58.498714image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median3
Q38
95-th percentile26
Maximum355
Range354
Interquartile range (IQR)7

Descriptive statistics

Standard deviation10.98446699
Coefficient of variation (CV)1.546608157
Kurtosis53.2773348
Mean7.102294748
Median Absolute Deviation (MAD)2
Skewness5.155118644
Sum3448782
Variance120.6585151
MonotocityNot monotonic
2020-12-06T07:55:58.919328image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
114676430.2%
 
26349813.1%
 
3443239.1%
 
4329116.8%
 
5259455.3%
 
6212604.4%
 
7174633.6%
 
8151023.1%
 
9126672.6%
 
10109332.3%
 
Other values (185)9472119.5%
 
ValueCountFrequency (%) 
114676430.2%
 
26349813.1%
 
3443239.1%
 
4329116.8%
 
5259455.3%
 
ValueCountFrequency (%) 
3551< 0.1%
 
3301< 0.1%
 
3154< 0.1%
 
2972< 0.1%
 
2812< 0.1%
 

Reviewer_Score
Real number (ℝ≥0)

Distinct37
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.402592532
Minimum2.5
Maximum10
Zeros0
Zeros (%)0.0%
Memory size3.7 MiB
2020-12-06T07:55:59.617066image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum2.5
5-th percentile5
Q17.5
median8.8
Q39.6
95-th percentile10
Maximum10
Range7.5
Interquartile range (IQR)2.1

Descriptive statistics

Standard deviation1.636499496
Coefficient of variation (CV)0.1947612585
Kurtosis0.9824423663
Mean8.402592532
Median Absolute Deviation (MAD)1.2
Skewness-1.198372938
Sum4080189.7
Variance2.678130602
MonotocityNot monotonic
2020-12-06T07:55:59.951103image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%) 
1011014222.7%
 
9.66726613.9%
 
9.25514311.4%
 
8.8434558.9%
 
8.3385437.9%
 
7.5327276.7%
 
7.9309976.4%
 
7.1232784.8%
 
6.7175753.6%
 
6.3139652.9%
 
Other values (27)5249610.8%
 
ValueCountFrequency (%) 
2.520380.4%
 
2.914800.3%
 
334< 0.1%
 
3.18< 0.1%
 
3.326130.5%
 
ValueCountFrequency (%) 
1011014222.7%
 
9.66726613.9%
 
9.56820.1%
 
9.457< 0.1%
 
9.25514311.4%
 

Tags
Categorical

HIGH CARDINALITY

Distinct52838
Distinct (%)10.9%
Missing0
Missing (%)0.0%
Memory size3.7 MiB
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']
 
4691
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']
 
4660
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']
 
4206
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']
 
3959
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']
 
2928
Other values (52833)
465143 
ValueCountFrequency (%) 
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']46911.0%
 
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']46601.0%
 
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']42060.9%
 
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']39590.8%
 
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']29280.6%
 
[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']29170.6%
 
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']27520.6%
 
[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ']25720.5%
 
[' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 1 night ']24540.5%
 
[' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']22870.5%
 
Other values (52828)45216193.1%
 
2020-12-06T07:56:00.610676image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Frequencies of value counts

Unique

Unique28587 ?
Unique (%)5.9%
2020-12-06T07:56:00.991594image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length213
Median length108
Mean length102.4322665
Min length11

days_since_review
Categorical

HIGH CARDINALITY

Distinct731
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.7 MiB
1 days
 
2452
322 day
 
2170
120 day
 
2157
534 day
 
1851
338 day
 
1850
Other values (726)
475107 
ValueCountFrequency (%) 
1 days24520.5%
 
322 day21700.4%
 
120 day21570.4%
 
534 day18510.4%
 
338 day18500.4%
 
394 day17990.4%
 
429 day17670.4%
 
387 day17200.4%
 
241 day16910.3%
 
366 day16810.3%
 
Other values (721)46644996.1%
 
2020-12-06T07:56:01.414738image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%
2020-12-06T07:56:01.755781image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram of lengths of the category

Length

Max length7
Median length7
Mean length6.984140844
Min length6

lat
Real number (ℝ≥0)

Distinct1404
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean49.47479932
Minimum41.3283758
Maximum52.4001813
Zeros0
Zeros (%)0.0%
Memory size3.7 MiB
2020-12-06T07:56:02.077049image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum41.3283758
5-th percentile41.386136
Q148.8346811
median51.5013149
Q351.5166755
95-th percentile52.369391
Maximum52.4001813
Range11.0718055
Interquartile range (IQR)2.6819944

Descriptive statistics

Standard deviation3.484356032
Coefficient of variation (CV)0.07042688561
Kurtosis0.7584232953
Mean49.47479932
Median Absolute Deviation (MAD)0.0445327
Skewness-1.452080311
Sum24024319.38
Variance12.14073696
MonotocityNot monotonic
2020-12-06T07:56:02.433635image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
51.501909747891.0%
 
51.511099342560.9%
 
51.49904635780.7%
 
51.510841232120.7%
 
51.510994529580.6%
 
51.519568826280.5%
 
51.493508325650.5%
 
51.502434825510.5%
 
51.513555522880.5%
 
51.557696222270.5%
 
Other values (1394)45453593.6%
 
ValueCountFrequency (%) 
41.32837585720.1%
 
41.3684375750.1%
 
41.3703041229< 0.1%
 
41.37130810820.2%
 
41.3725246120< 0.1%
 
ValueCountFrequency (%) 
52.40018133120.1%
 
52.39248984670.1%
 
52.3923684143< 0.1%
 
52.38728848560.2%
 
52.385649410710.2%
 

lng
Real number (ℝ)

Distinct1404
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.630325181
Minimum-0.3192925
Maximum16.4217627
Zeros0
Zeros (%)0.0%
Memory size3.7 MiB
2020-12-06T07:56:02.799507image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Quantile statistics

Minimum-0.3192925
5-th percentile-0.1949706
Q1-0.1444623
median-0.0071375
Q32.3556545
95-th percentile16.3546297
Maximum16.4217627
Range16.7410552
Interquartile range (IQR)2.5001168

Descriptive statistics

Standard deviation4.43069956
Coefficient of variation (CV)1.684468366
Kurtosis3.513074748
Mean2.630325181
Median Absolute Deviation (MAD)0.2217223
Skewness2.056953327
Sum1277251.714
Variance19.6310986
MonotocityNot monotonic
2020-12-06T07:56:03.138444image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
-0.023220847891.0%
 
-0.120867342560.9%
 
-0.191707335780.7%
 
-0.078058132120.7%
 
-0.186341729580.6%
 
-0.17052126280.5%
 
-0.183434625650.5%
 
-0.000249725510.5%
 
-0.18000222880.5%
 
-0.283526322270.5%
 
Other values (1394)45453593.6%
 
ValueCountFrequency (%) 
-0.31929253910.1%
 
-0.306071128< 0.1%
 
-0.29150523850.1%
 
-0.2907066800.1%
 
-0.286494512120.2%
 
ValueCountFrequency (%) 
16.42176274260.1%
 
16.42009574310.1%
 
16.4133973191< 0.1%
 
16.41294935010.1%
 
16.411699792< 0.1%
 

Interactions

2020-12-06T07:55:03.851610image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:04.225737image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:04.631519image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:05.001905image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:05.409704image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:05.808224image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:06.214230image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:06.595731image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:06.975342image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:07.479344image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:07.871333image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:08.245738image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:08.636423image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:09.061767image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:09.525609image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:09.991565image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:10.367144image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:10.911853image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:11.309593image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:11.703107image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:12.095721image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:12.493617image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:12.890247image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:13.310394image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:13.718796image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:14.101499image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:14.471432image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:14.844942image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:15.193027image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:15.558680image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:15.930145image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:16.302864image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:16.685864image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:17.059822image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:17.468420image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:17.831827image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:18.192020image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:18.600870image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:18.990808image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:19.398930image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:19.786508image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:20.203351image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:20.606757image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:21.013260image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:21.392979image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:21.787344image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:22.179262image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:22.574792image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:23.075817image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:23.705428image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:24.115413image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:24.526432image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:24.911886image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:25.286521image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:25.665189image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:26.043288image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:26.427393image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:26.817110image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:27.214243image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:27.614444image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:28.009999image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:28.388158image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:28.757363image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:29.138600image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:29.524000image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:29.906104image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:30.277812image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:30.645019image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:31.028391image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:31.417768image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:31.847453image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:32.274298image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:32.638141image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:33.009293image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:33.415049image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:33.812296image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:34.225824image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:34.639385image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:35.036416image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:35.422340image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:35.785183image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Correlations

2020-12-06T07:56:03.438609image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2020-12-06T07:56:03.786551image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2020-12-06T07:56:04.160514image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2020-12-06T07:56:04.518410image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2020-12-06T07:55:38.159415image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/
2020-12-06T07:55:40.282980image/svg+xmlMatplotlib v3.3.3, https://matplotlib.org/

Sample

First rows

Hotel_AddressAdditional_Number_of_ScoringReview_DateAverage_ScoreHotel_NameReviewer_NationalityNegative_ReviewReview_Total_Negative_Word_CountsTotal_Number_of_ReviewsPositive_ReviewReview_Total_Positive_Word_CountsTotal_Number_of_Reviews_Reviewer_Has_GivenReviewer_ScoreTagsdays_since_reviewlatlng
0s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1948/3/20177.7Hotel ArenaRussiaI am so angry that i made this post available via all possible sites i use when planing my trips so no one will make the mistake of booking this place I made my booking via booking com We stayed for 6 nights in this hotel from 11 to 17 July Upon arrival we were placed in a small room on the 2nd floor of the hotel It turned out that this was not the room we booked I had specially reserved the 2 level duplex room so that we would have a big windows and high ceilings The room itself was ok if you don t mind the broken window that can not be closed hello rain and a mini fridge that contained some sort of a bio weapon at least i guessed so by the smell of it I intimately asked to change the room and after explaining 2 times that i booked a duplex btw it costs the same as a simple double but got way more volume due to the high ceiling was offered a room but only the next day SO i had to check out the next day before 11 o clock in order to get the room i waned to Not the best way to begin your holiday So we had to wait till 13 00 in order to check in my new room what a wonderful waist of my time The room 023 i got was just as i wanted to peaceful internal garden view big window We were tired from waiting the room so we placed our belongings and rushed to the city In the evening it turned out that there was a constant noise in the room i guess it was made by vibrating vent tubes or something it was constant and annoying as hell AND it did not stop even at 2 am making it hard to fall asleep for me and my wife I have an audio recording that i can not attach here but if you want i can send it via e mail The next day the technician came but was not able to determine the cause of the disturbing sound so i was offered to change the room once again the hotel was fully booked and they had only 1 room left the one that was smaller but seems newer3971403Only the park outside of the hotel was beautiful11.07.02.9[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 6 nights ']0 days52.3605764.915968
1s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1948/3/20177.7Hotel ArenaIrelandNo Negative01403No real complaints the hotel was great great location surroundings rooms amenities and service Two recommendations however firstly the staff upon check in are very confusing regarding deposit payments and the staff offer you upon checkout to refund your original payment and you can make a new one Bit confusing Secondly the on site restaurant is a bit lacking very well thought out and excellent quality food for anyone of a vegetarian or vegan background but even a wrap or toasted sandwich option would be great Aside from those minor minor things fantastic spot and will be back when i return to Amsterdam105.07.07.5[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 4 nights ']0 days52.3605764.915968
2s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1947/31/20177.7Hotel ArenaAustraliaRooms are nice but for elderly a bit difficult as most rooms are two story with narrow steps So ask for single level Inside the rooms are very very basic just tea coffee and boiler and no bar empty fridge421403Location was good and staff were ok It is cute hotel the breakfast range is nice Will go back21.09.07.1[' Leisure trip ', ' Family with young children ', ' Duplex Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']3 days52.3605764.915968
3s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1947/31/20177.7Hotel ArenaUnited KingdomMy room was dirty and I was afraid to walk barefoot on the floor which looked as if it was not cleaned in weeks White furniture which looked nice in pictures was dirty too and the door looked like it was attacked by an angry dog My shower drain was clogged and the staff did not respond to my request to clean it On a day with heavy rainfall a pretty common occurrence in Amsterdam the roof in my room was leaking luckily not on the bed you could also see signs of earlier water damage I also saw insects running on the floor Overall the second floor of the property looked dirty and badly kept On top of all of this a repairman who came to fix something in a room next door at midnight was very noisy as were many of the guests I understand the challenges of running a hotel in an old building but this negligence is inconsistent with prices demanded by the hotel On the last night after I complained about water damage the night shift manager offered to move me to a different room but that offer came pretty late around midnight when I was already in bed and ready to sleep2101403Great location in nice surroundings the bar and restaurant are nice and have a lovely outdoor area The building also has quite some character26.01.03.8[' Leisure trip ', ' Solo traveler ', ' Duplex Double Room ', ' Stayed 3 nights ']3 days52.3605764.915968
4s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1947/24/20177.7Hotel ArenaNew ZealandYou When I booked with your company on line you showed me pictures of a room I thought I was getting and paying for and then when we arrived that s room was booked and the staff told me we could only book the villa suite theough them directly Which was completely false advertising After being there we realised that you have grouped lots of rooms on the photos together leaving me the consumer confused and extreamly disgruntled especially as its my my wife s 40th birthday present Please make your website more clear through pricing and photos as again I didn t really know what I was paying for and how much it had wnded up being Your photos told me I was getting something I wasn t Not happy and won t be using you again1401403Amazing location and building Romantic setting8.03.06.7[' Leisure trip ', ' Couple ', ' Suite ', ' Stayed 2 nights ', ' Submitted from a mobile device ']10 days52.3605764.915968
5s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1947/24/20177.7Hotel ArenaPolandBackyard of the hotel is total mess shouldn t happen in hotel with 4 stars171403Good restaurant with modern design great chill out place Great park nearby the hotel and awesome main stairs20.01.06.7[' Leisure trip ', ' Group ', ' Duplex Double Room ', ' Stayed 1 night ']10 days52.3605764.915968
6s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1947/17/20177.7Hotel ArenaUnited KingdomCleaner did not change our sheet and duvet everyday but just made bed They also didn t clean the floor and changed the body gel when we run out of it331403The room is spacious and bright The hotel is located in a quiet and beautiful park18.06.04.6[' Leisure trip ', ' Group ', ' Duplex Twin Room ', ' Stayed 5 nights ', ' Submitted from a mobile device ']17 days52.3605764.915968
7s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1947/17/20177.7Hotel ArenaUnited KingdomApart from the price for the brekfast Everything very good111403Good location Set in a lovely park friendly staff Food high quality We Oth enjoyed the breakfast19.01.010.0[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']17 days52.3605764.915968
8s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1947/9/20177.7Hotel ArenaBelgiumEven though the pictures show very clean rooms the actual room was quit dirty and outlived Also check in is at 15 o clock but our room was not ready at that time341403No Positive0.03.06.5[' Leisure trip ', ' Couple ', ' Duplex Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']25 days52.3605764.915968
9s Gravesandestraat 55 Oost 1092 AA Amsterdam Netherlands1947/8/20177.7Hotel ArenaNorwayThe aircondition makes so much noise and its hard to sleep at night151403The room was big enough and the bed is good The breakfast food and service on the hotel is good outside the hotel there is a big park which is very good for walk in the morning and evening Many people are having picnics and do some bicycling50.01.07.9[' Leisure trip ', ' Couple ', ' Large King Room ', ' Stayed 7 nights ']26 days52.3605764.915968

Last rows

Hotel_AddressAdditional_Number_of_ScoringReview_DateAverage_ScoreHotel_NameReviewer_NationalityNegative_ReviewReview_Total_Negative_Word_CountsTotal_Number_of_ReviewsPositive_ReviewReview_Total_Positive_Word_CountsTotal_Number_of_Reviews_Reviewer_Has_GivenReviewer_ScoreTagsdays_since_reviewlatlng
485577Via Senato 22 Milan City Center 20121 Milan Italy11611/26/20159.0Senato Hotel MilanoLebanonNo Negative01031Everything was perfect5.012.010.0[' Leisure trip ', ' Couple ', ' Classic Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']616 day45.4714069.19653
485578Via Senato 22 Milan City Center 20121 Milan Italy11611/22/20159.0Senato Hotel MilanoBulgariaNon21031Very modern rooms comfortable bed Perfect breacfast great location11.011.09.6[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']620 day45.4714069.19653
485579Via Senato 22 Milan City Center 20121 Milan Italy11611/21/20159.0Senato Hotel MilanoUnited States of AmericaNo Negative01031Very helpful people A lovely design of the rooms and public spaces14.01.08.8[' Business trip ', ' Group ', ' Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device ']621 day45.4714069.19653
485580Via Senato 22 Milan City Center 20121 Milan Italy11611/19/20159.0Senato Hotel MilanoUnited States of AmericaNo Negative01031a little far from subway but very close to the main fashion area15.07.09.2[' Leisure trip ', ' Couple ', ' Double Room with Terrace ', ' Stayed 1 night ']623 day45.4714069.19653
485581Via Senato 22 Milan City Center 20121 Milan Italy11611/17/20159.0Senato Hotel MilanoHong KongNo Negative01031Easy to access all the major area Staffs are nice Room r tidy with all the essential19.01.08.3[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 4 nights ', ' Submitted from a mobile device ']625 day45.4714069.19653
485582Via Senato 22 Milan City Center 20121 Milan Italy11611/16/20159.0Senato Hotel MilanoBelgiumNo Negative01031Beautiful design perfect location great breakfast And friendly staf11.029.010.0[' Leisure trip ', ' Family with older children ', ' Superior Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']626 day45.4714069.19653
485583Via Senato 22 Milan City Center 20121 Milan Italy11611/12/20159.0Senato Hotel MilanoSaudi ArabiaThe room was very small71031The location and cleanless5.09.06.3[' Leisure trip ', ' Solo traveler ', ' Single Room ', ' Stayed 1 night ']630 day45.4714069.19653
485584Via Senato 22 Milan City Center 20121 Milan Italy11611/12/20159.0Senato Hotel MilanoUnited States of AmericaThe pendant lights at the night stand only worked one side Far walk from subway171031Nicely designed hotel Good location near the action10.07.08.8[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']630 day45.4714069.19653
485585Via Senato 22 Milan City Center 20121 Milan Italy11611/10/20159.0Senato Hotel MilanoTurkeyNo Negative01031Rooms Breakfast Location4.03.010.0[' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 3 nights ']632 day45.4714069.19653
485586Via Senato 22 Milan City Center 20121 Milan Italy11611/8/20159.0Senato Hotel MilanoIndiaNo Negative01031Excellent ambience created by very thoughtful interior design10.04.09.2[' Leisure trip ', ' Solo traveler ', ' Classic Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']634 day45.4714069.19653

Duplicate rows

Most frequent

Hotel_AddressAdditional_Number_of_ScoringReview_DateAverage_ScoreHotel_NameReviewer_NationalityNegative_ReviewReview_Total_Negative_Word_CountsTotal_Number_of_ReviewsPositive_ReviewReview_Total_Positive_Word_CountsTotal_Number_of_Reviews_Reviewer_Has_GivenReviewer_ScoreTagsdays_since_reviewlatlngcount
0100 110 Euston Road Camden London NW1 2AJ United Kingdom7282/25/20178.9Pullman London St PancrasChinanone23168good location and super nice staff room is big and great13.039.09.6[' Business trip ', ' Solo traveler ', ' Classic King Room ', ' Stayed 1 night ', ' Submitted from a mobile device ']159 day51.528677-0.1283492
116 22 Great Russell Street Camden London WC1B 3NN United Kingdom3007/27/20179.0The Bloomsbury HotelIsraelNo Negative01254The attention received by Sebastian and his team was exceptional12.04.09.6[' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']7 days51.517167-0.1290532
2167 rue de Rome 17th arr 75017 Paris France1110/14/20166.8Villa EugenieAlbaniaThey didnt change the sheets They also had a minibar coca and nestea cannets They didnt tell us that it was with payment and we had to pay 30 euros for 5 of them What an abusive bill40165The room was cozy and pretty7.03.05.8[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 3 nights ']293 day48.8871282.3142052
3167 rue de Rome 17th arr 75017 Paris France1110/14/20166.8Villa EugenieIranEvry thing was wrong Cold room Dark room No refrigetor in room No ac Evry thing was baaaaaaad Very bad21165This hotel was terrible this place worst place in paris Hostel is better than this place I m sorry for myself to spend my time in this place29.02.02.5[' Solo traveler ', ' Single Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']293 day48.8871282.3142052
4167 rue de Rome 17th arr 75017 Paris France1110/14/20166.8Villa EugenieUnited KingdomEvry thing of this place i can t name horlrel to this place was wrong and out of repair all lamp were nt work 2nights i got cold in cold room Ac not working i so sorry for my self that i had to spend my time in this ruin place 4star hotel has nt refrigerator58165This hotel is worst hotel Its terrible9.01.02.5[' Solo traveler ', ' Single Room ', ' Stayed 2 nights ', ' Submitted from a mobile device ']293 day48.8871282.3142052
5167 rue de Rome 17th arr 75017 Paris France1110/18/20166.8Villa EugenieIsraelNo Negative0165the room was very french and beautiful it was good location and I enjoyed to stay there18.01.09.2[' Leisure trip ', ' Couple ', ' Twin Room ', ' Stayed 3 nights ']289 day48.8871282.3142052
6167 rue de Rome 17th arr 75017 Paris France1110/18/20166.8Villa EugenieUnited KingdomNo internet it was important for me for my business Really Small Room Very Bad Location No Shampoo and staff etc You need to call them to bring All Bad sorry32165Didier was friendly and good7.012.02.5[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 4 nights ']289 day48.8871282.3142052
7167 rue de Rome 17th arr 75017 Paris France1110/19/20166.8Villa EugenieSwitzerlandWifi was not working6165No Positive0.01.07.9[' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 2 nights ']288 day48.8871282.3142052
8167 rue de Rome 17th arr 75017 Paris France1110/2/20166.8Villa EugenieQatarStaff very rude My credit card was charged Before my stay and while Checking out they charged me again when I told the receptionist about it her answer was I m not trying to steal your money madam in a ver un polite way Blaming my Bank about it Very poor selection for breakfast56165Nothing3.08.05.0[' Leisure trip ', ' Family with young children ', ' Two Connecting Double Rooms ', ' Stayed 2 nights ', ' Submitted from a mobile device ']305 day48.8871282.3142052
9167 rue de Rome 17th arr 75017 Paris France1110/20/20166.8Villa EugenieLithuaniaWe booked hotel for 3 nights and there was no normal internet connection From all trip time we had internet only for 1 2 huors Also there is very noisy almoust impossible to sleep with open window39165Good place4.09.06.7[' Business trip ', ' Group ', ' Superior Double Room ', ' Stayed 3 nights ']287 day48.8871282.3142052